/ Assembly List / LJCDBDataAccess / DbDataAccess / Load

Namespace - LJCDBDataAccess


Returns

The result XML message.

Syntax

C#
private DbResult Load()

Retrieves multiple data rows. (E)

Remarks

This method is called from the Execute() method if the DbRequest.QueryType is "Load".

Example

C#
// Loads multiple Person objects.
private static Persons Load(DbDataAccess dbDataAccess
    , DbColumns dataDefinition)
{
    Person retValue = null;

    // Create the list of included columns.
    // This list should include the database assigned columns.
    List<string> columnNames = new List<string>();
    foreach (DbColumn column in dataDefinition)
    {
        columnNames.Add(column.ColumnName);
    }

    // Create a Data Columns object with the included data definitions
    // and values from the data record.
    var dataColumns = DbCommon.QueryColumns(columnNames, dataDefinition);

    // Create Key Columns.
    var keyColumns = new DbColumns()
    {
        { "Name", (object)"TestName" }
    };
    dataDefinition.LJCSetExcludeKeyValue("PrincipleFlag");
 
    var queryKeyColumns = DbCommon.QueryKeys(keyColumns, dataDefinition);

    // Create a query with the retrieve columns.
    // The retrieved columns should include the DB assigned columns.
    DbRequest dbRequest = new DbRequest()
    {
        Columns = dataColumns
        //KeyColumns = queryKeyColumns
        QueryType = QueryType.Load.ToString(),
        TableName = "PersonTest",
    };
    DbResult dbResult = dbDataAccess.Execute(dbRequest);

    if (dbResult != null)
    {
        string sqlStatement = dbResult.ExecutedSql;
        if (dbResult.DbRecords != null && dbResult.DbRecords.Count > 0)
        {
            retValue = new Persons();
            foreach (DbValues dbValues in dbResult.DbRecords)
            {
                Person person = new Person();
                DbCommon.SetObjectValues(dbValues, retValue);
                retValue.Add(person);
            }
        }
    }
    return retValue;
}

Copyright © Lester J. Clark and Contributors.
Licensed under the MIT License.